package com.lxxie.dao;

import com.lxxie.entity.SqlHistory;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by xielx on 21/1/22 14:11
 */
public interface SqlHistoryRepository extends JpaRepository<SqlHistory,String> {

        @Query(value = "SELECT top 100 * FROM SQL_HISTORY order by gxsj desc",nativeQuery = true)
        List<SqlHistory> findTop100His();
}
